Flexible Active Safety Motion Control For Robotic Obstacle Avoidance: A Cbf-Guided Mpc Approach